{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["список","таблица критериев","средний балл","Лист3"],"not_rendered":{"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"список","index":0,"n_rows":53,"n_cols":1,"rows_kept":53}
["Россия"]
["Республ"]
["Муницип"]
["Школа"]
[]
["Участник"]
["Призер"]
["Победит"]
[]
["Офиц.(Минист)"]
["Другие"]
[]
["Очные"]
["Заочные"]
[]
["Индивид."]
["Массовые"]
[]
["Офиц.(Минист)"]
[]
["Очная"]
[]
["Победит"]
["Призер"]
[]
["одно мероп."]
["два и более"]
[]
["Грант уч/поб."]
["Конкурс поб."]
["Конкурс приз."]
["Конкурс участ."]
[]
["Выст. связ. со шк."]
["Выст. не св. со шк."]
["пассив. учас."]
[]
["Мат, физ., хим"]
["9, 11 кл"]
["4, 6, 8, 10 кл"]
["5, 7 кл"]
["1,2,3 кл"]
[]
["Мат., физ, хим"]
["Русс, тат, ин.яз"]
["Другие"]
[]
["Ведение документации"]
["Инструктажи по безоп., дневник"]
["Организация работы класса"]
["Участие в общешкольных делах"]
["Руководство общественными орг."]
["Взаимодействие с родителями"]

{"sheet":"таблица критериев","index":1,"n_rows":30,"n_cols":13,"rows_kept":30,"merged":[[2,4,2,6],[2,9,2,10],[3,0,5,0],[3,1,5,1],[3,4,3,6],[3,9,3,10],[4,4,4,6],[4,9,4,10],[5,4,5,6],[5,9,5,10],[6,0,8,0],[6,1,8,1],[6,4,6,6],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,4,8,6],[8,9,8,10],[9,0,10,0],[9,1,10,1],[9,4,9,6],[9,9,9,10],[9,12,10,12],[10,4,10,6],[10,9,10,10],[11,0,15,0],[11,1,15,1],[11,2,15,2],[11,3,15,3],[11,7,15,8],[11,12,15,12],[16,0,20,0],[16,1,20,1],[16,2,20,2],[16,3,20,3],[16,7,20,8],[16,12,20,12],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,21,6],[21,7,22,8],[21,9,21,11],[21,12,22,12],[22,4,22,6],[22,9,22,11],[23,0,24,0],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,7,24,8],[23,12,24,12],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,7,26,8],[25,12,26,12],[27,4,27,6],[27,7,27,8],[27,9,27,11]]}
["Оценочный лист эффективности деятельности педагогических работников МБОУ \"Тимяшевская СОШ\""]
[null,null,"Ф.И.О. Учителя"]
["№","Наименование критерия","Параллель, название работы","Диапазон значений","Итоговое значение (из оценочного листа)",null,null,"Весовой коэф.","Группа слож.","Коэф. Группы сл.",null,"Расч. по формуле","Балл"]
[1,"Успеваемость обучающихся (годовая)",null,"93-100",{"$nulls":3},10,null,{"$f":"IF(I4=\"Мат, физ., хим\",1.2,IF(I4=\"9, 11 кл\",1,IF(I4=\"4, 6, 8, 10 кл\",0.9,IF(I4=\"5, 7 кл\",0.8,IF(I4=\"1,2,3 кл\",0.7,0)))))","v":0},null,{"$f":"IF(((E4-93)/7)*H$4*J4<0,0,IF(((E4-93)/7)*H$4*J4>H$4,H$4,((E4-93)/7)*H$4*J4))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(I5=\"Мат, физ., хим\",1.2,IF(I5=\"9, 11 кл\",1,IF(I5=\"4, 6, 8, 10 кл\",0.9,IF(I5=\"5, 7 кл\",0.8,IF(I5=\"1,2,3 кл\",0.7,0)))))","v":0},null,{"$f":"IF(((E5-93)/7)*H$4*J5<0,0,IF(((E5-93)/7)*H$4*J5>H$4,H$4,((E5-93)/7)*H$4*J5))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J6<>0,(L4+L5+L6)/3,IF(J5<>0,(L4+L5)/2,L4))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(I6=\"Мат, физ., хим\",1.2,IF(I6=\"9, 11 кл\",1,IF(I6=\"4, 6, 8, 10 кл\",0.9,IF(I6=\"5, 7 кл\",0.8,IF(I6=\"1,2,3 кл\",0.7,0)))))","v":0},null,{"v":0,"d":"0.00"}]
[2,"Качество знаний обучающихся по итогам соответствующего вида контроля знаний (п.1)(годовая)",null,"40-85",{"$nulls":3},10,null,{"$f":"IF(I7=\"Мат., физ, хим\",1.2,IF(I7=\"Русс, тат, ин.яз\",1,IF(I7=\"Другие\",0.7,0)))","v":0},null,{"$f":"IF(((E7-40)/45)*H$7*J7<0,0,IF(((E7-40)/45)*H$7*J7>H$7,H$7,((E7-40)/45)*H$7*J7))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(I8=\"Мат., физ, хим\",1.2,IF(I8=\"Русс, тат, ин.яз\",1,IF(I8=\"Другие\",0.7,0)))","v":0},null,{"$f":"IF(((E8-40)/45)*H$7*J8<0,0,IF(((E8-40)/45)*H$7*J8>H$7,H$7,((E8-40)/45)*H$7*J8))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J9<>0,(L7+L8+L9)/3,IF(J8<>0,(L7+L8)/2,L7))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},0,null,{"v":0,"d":"0.00"}]
[3,"Динамика среднего балла по предмету по всем классам (полугодовая)","1 полугодие","99-105",{"$nulls":3},8,{"$nulls":3},{"$f":"IF(E10<>0,(E11/E10*100-99)/6*H10,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(L10>8,8,IF(L10<0,0,L10))","v":{"v":0,"d":"0.00"}}]
[null,null,"2 полугодие"]
[4,"Подготовка  обучающихся – призеров и дипломантов предметных олимпиад  по предмету","Полугодовая","0-6",{"$nulls":3},6,null,{"$f":"IF(E12=\"муницип\",4,IF(E12=\"республ\",5,IF(E12=\"Россия\",6,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(OR(E13=\"Участник\",E14=\"другие\",E15=\"Заочные\"),0,IF(F12=\"муницип\",4,IF(F12=\"республ\",5,IF(F12=\"Россия\",6,0))))","v":{"v":0,"d":"0.00"}},{"$f":"IF(OR(E13=\"Участник\",E14=\"другие\",E15=\"Заочные\"),0,IF(G12=\"муницип\",4,IF(G12=\"республ\",5,IF(G12=\"Россия\",6,0))))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J12*(J13+J14+J15+J16)/4+L12*(L13+L14+L15+L16)/4+K12*(K13+K14+K15+K16)/4>6,6,J12*(J13+J14+J15+J16)/4+L12*(L13+L14+L15+L16)/4+K12*(K13+K14+K15+K16)/4)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(E13=\"Участник\",0.5,IF(E13=\"Призер\",0.8,IF(E13=\"Победит\",1,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F13=\"Участник\",0.5,IF(F13=\"Призер\",0.8,IF(F13=\"Победит\",1,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G13=\"Участник\",0.5,IF(G13=\"Призер\",0.8,IF(G13=\"Победит\",1,0)))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(E14=\"Офиц.(Минист)\",1,IF(E14=\"Другие\",0.3,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F14=\"Офиц.(Минист)\",1,IF(F14=\"Другие\",0.3,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G14=\"Офиц.(Минист)\",1,IF(G14=\"Другие\",0.3,0))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(E15=\"Очные\",1,IF(E15=\"Заочные\",0.3,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F15=\"Очные\",1,IF(F15=\"Заочные\",0.3,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G15=\"Очные\",1,IF(G15=\"Заочные\",0.3,0))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(E16=\"Индивид.\",1,IF(E16=\"Массовые\",0.5,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F16=\"Индивид.\",1,IF(F16=\"Массовые\",0.5,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G16=\"Индивид.\",1,IF(G16=\"Массовые\",0.5,0))","v":{"v":0,"d":"0.00"}}]
[5,"Подготовка  обучающихся - призеров  и дипломантов конференций, конкурсов  по предмету","Полугодовая","0-5",{"$nulls":3},5,null,{"$f":"IF(E17=\"муницип\",3,IF(E17=\"республ\",4,IF(E17=\"Россия\",5,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(OR(E18=\"Участник\",E19=\"другие\"),0,IF(F17=\"муницип\",3,IF(F17=\"республ\",4,IF(F17=\"Россия\",5,0))))","v":{"v":0,"d":"0.00"}},{"$f":"IF(OR(E18=\"Участник\",E19=\"другие\"),0,IF(G17=\"муницип\",3,IF(G17=\"республ\",4,IF(G17=\"Россия\",5,0))))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J17*(J18+J19+J20+J21)/4+L17*(L18+L19+L20+L21)/4+K17*(K18+K19+K20+K21)/4>5,5,J17*(J18+J19+J20+J21)/4+L17*(L18+L19+L20+L21)/4+K17*(K18+K19+K20+K21)/4)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(E18=\"Участник\",0.5,IF(E18=\"Призер\",0.8,IF(E18=\"Победит\",1,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F18=\"Участник\",0.5,IF(F18=\"Призер\",0.8,IF(F18=\"Победит\",1,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G18=\"Участник\",0.5,IF(G18=\"Призер\",0.8,IF(G18=\"Победит\",1,0)))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(E19=\"Офиц.(Минист)\",1,IF(E19=\"Другие\",0.3,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F19=\"Офиц.(Минист)\",1,IF(F19=\"Другие\",0.3,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G19=\"Офиц.(Минист)\",1,IF(G19=\"Другие\",0.3,0))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(E20=\"Очные\",1,IF(E20=\"Заочные\",0.3,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F20=\"Очные\",1,IF(F20=\"Заочные\",0.3,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G20=\"Очные\",1,IF(G20=\"Заочные\",0.3,0))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(E21=\"Индивид.\",1,IF(E21=\"Массовые\",0.5,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F21=\"Индивид.\",1,IF(F21=\"Массовые\",0.5,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G21=\"Индивид.\",1,IF(G21=\"Массовые\",0.5,0))","v":{"v":0,"d":"0.00"}}]
[6,"Организация внеклассной  работы по предмету","Полугодовая","0-5",{"$nulls":3},5,null,{"$f":"IF(E22=\"муницип\",0.9,IF(E22=\"республ\",1,IF(E22=\"Россия\",1,IF(E22=\"Школа\",0.8,0))))","v":{"v":0,"d":"0.00"}},null,null,{"$f":"J22*J23","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(E23=\"одно мероп.\",2,IF(E23=\"два и более\",5,0))","v":{"v":0,"d":"0.00"}}]
[7,"Участие учителя в профессиональных научно-практических конференциях, семинарах","Полугодовая","0-5",{"$nulls":3},5,null,{"$f":"IF(E24=\"муницип\",3,IF(E24=\"республ\",4,IF(E24=\"Россия\",5,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F24=\"муницип\",3,IF(F24=\"республ\",4,IF(F24=\"Россия\",5,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G24=\"муницип\",3,IF(G24=\"республ\",4,IF(G24=\"Россия\",5,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J24*J25+L24*L25+K24*K25>5,5,J24*J25+L24*L25+K24*K25)","v":0}]
[{"$nulls":9},{"$f":"IF(E25=\"Выст. связ. со шк.\",1,IF(E25=\"Выст. не св. со шк.\",0.3,IF(E25=\"пассив. учас.\",0.1,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F25=\"Выст. связ. со шк.\",1,IF(F25=\"Выст. не св. со шк.\",0.3,IF(F25=\"пассив. учас.\",0.1,0)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G25=\"Выст. связ. со шк.\",1,IF(G25=\"Выст. не св. со шк.\",0.3,IF(G25=\"пассив. учас.\",0.1,0)))","v":{"v":0,"d":"0.00"}}]
[8,"Участие учителя в профессиональных конкурсах, грантах","Полугодовая","0-5",{"$nulls":3},5,null,{"$f":"IF(E26=\"муницип\",3,IF(E26=\"республ\",4,IF(E26=\"Россия\",5,0)))","v":0},{"$f":"IF(F26=\"муницип\",3,IF(F26=\"республ\",4,IF(F26=\"Россия\",5,0)))","v":0},{"$f":"IF(G26=\"муницип\",3,IF(G26=\"республ\",4,IF(G26=\"Россия\",5,0)))","v":0},{"$f":"IF(J26*J27+L26*L27+K26*K27>5,5,J26*J27+L26*L27+K26*K27)","v":0}]
[{"$nulls":9},{"$f":"IF(E27=\"Грант уч/поб.\",1,IF(E27=\"Конкурс поб.\",1,IF(E27=\"Конкурс приз.\",0.8,IF(E27=\"Конкурс участ.\",0.5,0))))","v":0},{"$f":"IF(F27=\"Грант уч/поб.\",1,IF(F27=\"Конкурс поб.\",1,IF(F27=\"Конкурс приз.\",0.8,IF(F27=\"Конкурс участ.\",0.5,0))))","v":0},{"$f":"IF(G27=\"Грант уч/поб.\",1,IF(G27=\"Конкурс поб.\",1,IF(G27=\"Конкурс приз.\",0.8,IF(G27=\"Конкурс участ.\",0.5,0))))","v":0}]
[9,"Наличие и уровень распространения передового педагогического опыта.","Годовая","0-6",{"$nulls":3},6,null,{"$f":"IF(E28=\"муницип\",2,IF(E28=\"республ\",4,IF(E28=\"Россия\",6,0)))","v":0},null,null,{"$f":"J28","v":0}]
[{"$nulls":11},"Итого:",{"$f":"M5+M8+M10+M12+M17+M22+M24+M26+M28","v":{"v":0,"d":"0.00"}}]
[null,"Ознакомлен и согласен: _________",{"$f":"E2","v":0},null,"  Дата заполнения: ",null,{"$f":"TODAY()","v":"2025-09-01"}]

{"sheet":"средний балл","index":2,"n_rows":21,"n_cols":13,"rows_kept":21,"merged":[[0,0,0,5],[0,8,0,11],[2,0,18,0],[19,0,19,1],[20,0,20,1]]}
["1 полугодие",{"$nulls":7},"2 полугодие"]
[null,"оценки",5,4,3,2,null,null,5,4,3,2]
["Классы"]
{"$rows_empty":16}
["кол оценок",null,{"$f":"SUM(C3:C19)","v":0},{"$f":"SUM(D3:D19)","v":0},{"$f":"SUM(E3:E19)","v":0},{"$f":"SUM(F3:F19)","v":0},{"$f":"SUM(C20:F20)","v":0},null,{"$f":"SUM(I3:I19)","v":0},{"$f":"SUM(J3:J19)","v":0},{"$f":"SUM(K3:K19)","v":0},{"$f":"SUM(L3:L19)","v":0},{"$f":"SUM(I20:L20)","v":0}]
["баллы",null,{"$f":"C20*5","v":0},{"$f":"D20*4","v":0},{"$f":"E20*3","v":0},{"$f":"F20*2","v":0},{"$f":"(C21+D21+E21+F21)/G20","v":{"$error":"#DIV/0!"}},null,{"$f":"I20*5","v":0},{"$f":"J20*4","v":0},{"$f":"K20*3","v":0},{"$f":"L20*2","v":0},{"$f":"(I21+J21+K21+L21)/M20","v":{"$error":"#DIV/0!"}}]

{"sheet":"Лист3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}